Overview

Dataset statistics

Number of variables48
Number of observations15407
Missing cells84314
Missing cells (%)11.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.6 MiB
Average record size in memory384.0 B

Variable types

CAT36
NUM12

Reproduction

Analysis started2020-06-10 20:12:51.876921
Analysis finished2020-06-10 20:13:20.033597
Duration28.16 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

Average Weekly Wage has a high cardinality: 1966 distinct values High cardinality
Claimant Atty Firm Name has a high cardinality: 453 distinct values High cardinality
Claimant Hire Date has a high cardinality: 4204 distinct values High cardinality
Detail Cause has a high cardinality: 63 distinct values High cardinality
Dt Reported to Carrier/TPA has a high cardinality: 3633 distinct values High cardinality
Dt Reported to Employer has a high cardinality: 4355 distinct values High cardinality
Date of Injury/Illness has a high cardinality: 4430 distinct values High cardinality
How Injury Occurred has a high cardinality: 15344 distinct values High cardinality
Injury/Illness City has a high cardinality: 1340 distinct values High cardinality
Injury/Illness Postal has a high cardinality: 1841 distinct values High cardinality
Injury/Illness State has a high cardinality: 53 distinct values High cardinality
Injury/Illness State Code has a high cardinality: 53 distinct values High cardinality
Detail Cause Code is highly correlated with Cause CodeHigh correlation
Cause Code is highly correlated with Detail Cause CodeHigh correlation
Claimant Gender Code is highly correlated with Claimant GenderHigh correlation
Claimant Gender is highly correlated with Claimant Gender CodeHigh correlation
Claimant Marital Status Code is highly correlated with Claimant Marital StatusHigh correlation
Claimant Marital Status is highly correlated with Claimant Marital Status CodeHigh correlation
Claimant State Code is highly correlated with Claimant StateHigh correlation
Claimant State is highly correlated with Claimant State CodeHigh correlation
Detail Cause is highly correlated with CauseHigh correlation
Cause is highly correlated with Detail CauseHigh correlation
Domestic vs. Foreign? Code is highly correlated with Domestic vs. Foreign?High correlation
Domestic vs. Foreign? is highly correlated with Domestic vs. Foreign? CodeHigh correlation
Employment Status Code is highly correlated with Employment StatusHigh correlation
Employment Status is highly correlated with Employment Status CodeHigh correlation
Injury/Illness State Code is highly correlated with Injury/Illness StateHigh correlation
Injury/Illness State is highly correlated with Injury/Illness State CodeHigh correlation
Jurisdiction Code is highly correlated with JurisdictionHigh correlation
Jurisdiction is highly correlated with Jurisdiction CodeHigh correlation
Lost Time or Medical Only? Code is highly correlated with Lost Time or Medical Only?High correlation
Lost Time or Medical Only? is highly correlated with Lost Time or Medical Only? CodeHigh correlation
OSHA Injury Type is highly correlated with Nature of Injury/IllnessHigh correlation
Nature of Injury/Illness is highly correlated with OSHA Injury Type and 2 other fieldsHigh correlation
Type of Loss is highly correlated with Nature of Injury/Illness and 1 other fieldsHigh correlation
Type of Loss Code is highly correlated with Nature of Injury/Illness and 1 other fieldsHigh correlation
Average Weekly Wage has 9535 (61.9%) missing values Missing
Claimant Age has 2163 (14.0%) missing values Missing
Claimant Atty Firm Name has 12410 (80.5%) missing values Missing
Claimant Hire Date has 901 (5.8%) missing values Missing
Claimant Marital Status has 12693 (82.4%) missing values Missing
Claimant Marital Status Code has 12693 (82.4%) missing values Missing
Department Code has 8123 (52.7%) missing values Missing
Injury/Illness Postal has 3684 (23.9%) missing values Missing
Number of Dependents has 14808 (96.1%) missing values Missing
Severity Index Code has 344 (2.2%) missing values Missing
Severity Index Code Code has 344 (2.2%) missing values Missing
Reforms_dummy has 6313 (41.0%) missing values Missing
Dependent is highly skewed (γ1 = 27.90114494) Skewed
How Injury Occurred is uniformly distributed Uniform
Obs_ID has unique values Unique
Dependent has 2689 (17.5%) zeros Zeros
Time of Injury/Illness has 2828 (18.4%) zeros Zeros

Variables

Obs_ID
Categorical

UNIQUE

Distinct count15407
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Obs_16009
 
1
Obs_7398
 
1
Obs_3079
 
1
Obs_15676
 
1
Obs_10003
 
1
Other values (15402)
15402
ValueCountFrequency (%) 
Obs_160091< 0.1%
 
Obs_73981< 0.1%
 
Obs_30791< 0.1%
 
Obs_156761< 0.1%
 
Obs_100031< 0.1%
 
Obs_29951< 0.1%
 
Obs_170591< 0.1%
 
Obs_52741< 0.1%
 
Obs_21411< 0.1%
 
Obs_158151< 0.1%
 
Other values (15397)1539799.9%
 

Length

Max length9
Median length8
Mean length8.407996365
Min length5

Dependent
Real number (ℝ≥0)

SKEWED
ZEROS

Distinct count5024
Unique (%)32.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10285.41370805478
Minimum0
Maximum3774290
Zeros2689
Zeros (%)17.5%
Memory size120.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1152
median446
Q31703.5
95-th percentile51491.9
Maximum3774290
Range3774290
Interquartile range (IQR)1551.5

Descriptive statistics

Standard deviation54196.59903
Coefficient of variation (CV)5.269267778
Kurtosis1591.997702
Mean10285.41371
Median Absolute Deviation (MAD)446
Skewness27.90114494
Sum158467369
Variance2937271346
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0268917.5%
 
154420.3%
 
150320.2%
 
222280.2%
 
215270.2%
 
180270.2%
 
232240.2%
 
3240.2%
 
167230.1%
 
199230.1%
 
Other values (5014)1246880.9%
 
ValueCountFrequency (%) 
0268917.5%
 
12< 0.1%
 
22< 0.1%
 
3240.2%
 
490.1%
 
ValueCountFrequency (%) 
37742901< 0.1%
 
11596311< 0.1%
 
10865221< 0.1%
 
10830671< 0.1%
 
10768831< 0.1%
 

Average Weekly Wage
Categorical

HIGH CARDINALITY
MISSING

Distinct count1966
Unique (%)33.5%
Missing9535
Missing (%)61.9%
Memory size120.4 KiB
500
 
383
320
 
204
1,000.00
 
180
600
 
149
150
 
126
Other values (1961)
4830
ValueCountFrequency (%) 
5003832.5%
 
3202041.3%
 
1,000.001801.2%
 
6001491.0%
 
1501260.8%
 
1001210.8%
 
400840.5%
 
1,500.00700.5%
 
1,200.00680.4%
 
300610.4%
 
Other values (1956)442628.7%
 
(Missing)953561.9%
 

Length

Max length8
Median length3
Mean length3.984812098
Min length1

Body Part
Categorical

Distinct count46
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Finger(s)
 
1426
Low Back Area
 
1317
Knee
 
1236
Other Facial Soft Tissue
 
1113
Eye(s)
 
1028
Other values (41)
9287
ValueCountFrequency (%) 
Finger(s)14269.3%
 
Low Back Area13178.5%
 
Knee12368.0%
 
Other Facial Soft Tissue11137.2%
 
Eye(s)10286.7%
 
Ankle9095.9%
 
Hand8165.3%
 
Shoulder(s)7404.8%
 
Foot6174.0%
 
Lower Leg5683.7%
 
Other values (36)563736.6%
 

Length

Max length54
Median length6
Mean length10.31161161
Min length3

Body Part Code
Real number (ℝ≥0)

Distinct count46
Unique (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.06542480690595
Minimum10
Maximum90
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum10
5-th percentile14
Q133
median38
Q353
95-th percentile65
Maximum90
Range80
Interquartile range (IQR)20

Descriptive statistics

Standard deviation17.20610687
Coefficient of variation (CV)0.4189925455
Kurtosis0.5526765595
Mean41.06542481
Median Absolute Deviation (MAD)15
Skewness0.4648007928
Sum632695
Variance296.0501137
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
3614269.3%
 
4213178.5%
 
5312368.0%
 
1811137.2%
 
1410286.7%
 
559095.9%
 
358165.3%
 
387404.8%
 
566174.0%
 
545683.7%
 
Other values (36)563736.6%
 
ValueCountFrequency (%) 
10270.2%
 
11180.1%
 
12370.2%
 
131280.8%
 
1410286.7%
 
ValueCountFrequency (%) 
905633.7%
 
66780.5%
 
653072.0%
 
63990.6%
 
62250.2%
 

Cause
Categorical

HIGH CORRELATION

Distinct count10
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Strain or Injury By
4174
Fall, Slip or Trip Injury
2662
Struck or Injured By
2533
Miscellaneous Causes
2004
Cut, Puncture, Scrape Injured By
1878
Other values (5)
2156
ValueCountFrequency (%) 
Strain or Injury By417427.1%
 
Fall, Slip or Trip Injury266217.3%
 
Struck or Injured By253316.4%
 
Miscellaneous Causes200413.0%
 
Cut, Puncture, Scrape Injured By187812.2%
 
Striking Against or Stepping on10096.5%
 
Caught In, Under or Between5583.6%
 
Motor Vehicle3582.3%
 
Burn or Scald - Heat or Cold Exposure2111.4%
 
Rubbed or Abraded By200.1%
 

Length

Max length37
Median length20
Mean length23.09975985
Min length13

Cause Code
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count10
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1497.0662685792172
Minimum1000
Maximum1900
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1000
5-th percentile1200
Q11300
median1500
Q31700
95-th percentile1900
Maximum1900
Range900
Interquartile range (IQR)400

Descriptive statistics

Standard deviation235.5560533
Coefficient of variation (CV)0.1573451077
Kurtosis-0.8318841983
Mean1497.066269
Median Absolute Deviation (MAD)200
Skewness0.114962866
Sum23065300
Variance55486.65425
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1500417427.1%
 
1300266217.3%
 
1700253316.4%
 
1900200413.0%
 
1200187812.2%
 
160010096.5%
 
11005583.6%
 
14003582.3%
 
10002111.4%
 
1800200.1%
 
ValueCountFrequency (%) 
10002111.4%
 
11005583.6%
 
1200187812.2%
 
1300266217.3%
 
14003582.3%
 
ValueCountFrequency (%) 
1900200413.0%
 
1800200.1%
 
1700253316.4%
 
160010096.5%
 
1500417427.1%
 

Claimant Age
Real number (ℝ≥0)

MISSING

Distinct count84
Unique (%)0.6%
Missing2163
Missing (%)14.0%
Infinite0
Infinite (%)0.0%
Mean40.286922379945636
Minimum1.0
Maximum91.0
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile23
Q131
median40
Q349
95-th percentile60
Maximum91
Range90
Interquartile range (IQR)18

Descriptive statistics

Standard deviation11.82069754
Coefficient of variation (CV)0.2934127713
Kurtosis-0.5246541589
Mean40.28692238
Median Absolute Deviation (MAD)9
Skewness0.1788198528
Sum533560
Variance139.7288904
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
414362.8%
 
433822.5%
 
363782.5%
 
473772.4%
 
463762.4%
 
453692.4%
 
403692.4%
 
393662.4%
 
343642.4%
 
243612.3%
 
Other values (74)946661.4%
 
(Missing)216314.0%
 
ValueCountFrequency (%) 
16< 0.1%
 
22< 0.1%
 
32< 0.1%
 
42< 0.1%
 
51< 0.1%
 
ValueCountFrequency (%) 
911< 0.1%
 
891< 0.1%
 
851< 0.1%
 
841< 0.1%
 
832< 0.1%
 

Claimant Atty Firm Name
Categorical

HIGH CARDINALITY
MISSING

Distinct count453
Unique (%)15.1%
Missing12410
Missing (%)80.5%
Memory size120.4 KiB
TLEVY, STERN & FORD
 
116
TJ. LEEDS BARROL, IV ATTORNEY AT LAW
 
58
TLEVY, FORD & WALLACH
 
51
TLEVY, STERN, & FORD
 
50
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO
 
37
Other values (448)
2685
ValueCountFrequency (%) 
TLEVY, STERN & FORD1160.8%
 
TJ. LEEDS BARROL, IV ATTORNEY AT LAW580.4%
 
TLEVY, FORD & WALLACH510.3%
 
TLEVY, STERN, & FORD500.3%
 
TCARUSO, SPILLANE, LEIGHTON,CONTRASTANO, ULANER & SAVINO370.2%
 
TLAW OFFICES OF MCNAMARA &360.2%
 
TMARDER, ESKESEN & NASS350.2%
 
TKLEIN WAGNER & MORRIS340.2%
 
TKLEE & WOOLF, LLP330.2%
 
TLAW OFFICE OF CHRISTINE T. NELSON330.2%
 
Other values (443)251416.3%
 
(Missing)1241080.5%
 

Length

Max length57
Median length3
Mean length7.532809762
Min length3

Claimant Gender
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Male
12375
Female
2950
Uknown
 
82
ValueCountFrequency (%) 
Male1237580.3%
 
Female295019.1%
 
Uknown820.5%
 

Length

Max length6
Median length4
Mean length4.39358733
Min length4

Claimant Gender Code
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
M
12375
F
2950
U
 
82
ValueCountFrequency (%) 
M1237580.3%
 
F295019.1%
 
U820.5%
 

Length

Max length1
Median length1
Mean length1
Min length1

Claimant Hire Date
Categorical

HIGH CARDINALITY
MISSING

Distinct count4204
Unique (%)29.0%
Missing901
Missing (%)5.8%
Memory size120.4 KiB
1/1/2005
 
130
2/27/2003
 
64
1/1/2001
 
63
1/1/2008
 
32
7/15/2002
 
27
Other values (4199)
14190
ValueCountFrequency (%) 
1/1/20051300.8%
 
2/27/2003640.4%
 
1/1/2001630.4%
 
1/1/2008320.2%
 
7/15/2002270.2%
 
1/7/2013270.2%
 
1/5/2009260.2%
 
7/1/2012250.2%
 
1/1/2013250.2%
 
1/5/2005240.2%
 
Other values (4194)1406391.3%
 
(Missing)9015.8%
 

Length

Max length10
Median length9
Mean length8.484195496
Min length3

Claimant Marital Status
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)0.1%
Missing12693
Missing (%)82.4%
Memory size120.4 KiB
Unmarried, Single, Widowed, Divorced
1435
Married
1258
Separated
 
21
ValueCountFrequency (%) 
Unmarried, Single, Widowed, Divorced14359.3%
 
Married12588.2%
 
Separated210.1%
 
(Missing)1269382.4%
 

Length

Max length36
Median length3
Mean length6.408385799
Min length3

Claimant Marital Status Code
Categorical

HIGH CORRELATION
MISSING

Distinct count3
Unique (%)0.1%
Missing12693
Missing (%)82.4%
Memory size120.4 KiB
U
1435
M
1258
S
 
21
ValueCountFrequency (%) 
U14359.3%
 
M12588.2%
 
S210.1%
 
(Missing)1269382.4%
 

Length

Max length3
Median length3
Mean length2.647692607
Min length1

Claimant State
Categorical

HIGH CORRELATION

Distinct count49
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
California
8912
New York
 
1121
New Mexico
 
610
Georgia
 
532
Texas
 
517
Other values (44)
3715
ValueCountFrequency (%) 
California891257.8%
 
New York11217.3%
 
New Mexico6104.0%
 
Georgia5323.5%
 
Texas5173.4%
 
North Carolina4993.2%
 
Louisiana4372.8%
 
New Jersey3412.2%
 
Florida2361.5%
 
Illinois2241.5%
 
Other values (39)197812.8%
 

Length

Max length25
Median length10
Mean length9.481469462
Min length4

Claimant State Code
Categorical

HIGH CORRELATION

Distinct count49
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
CA
8912
NY
 
1121
NM
 
610
GA
 
532
TX
 
517
Other values (44)
3715
ValueCountFrequency (%) 
CA891257.8%
 
NY11217.3%
 
NM6104.0%
 
GA5323.5%
 
TX5173.4%
 
NC4993.2%
 
LA4372.8%
 
NJ3412.2%
 
FL2361.5%
 
IL2241.5%
 
Other values (39)197812.8%
 

Length

Max length2
Median length2
Mean length2
Min length2

Department Code
Real number (ℝ≥0)

MISSING

Distinct count23
Unique (%)0.3%
Missing8123
Missing (%)52.7%
Infinite0
Infinite (%)0.0%
Mean12.119989017023613
Minimum1.0
Maximum23.0
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile2
Q16
median14
Q318
95-th percentile21
Maximum23
Range22
Interquartile range (IQR)12

Descriptive statistics

Standard deviation7.014638483
Coefficient of variation (CV)0.5787660758
Kurtosis-1.477812356
Mean12.11998902
Median Absolute Deviation (MAD)6
Skewness-0.1316306344
Sum88282
Variance49.20515304
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2111647.6%
 
179776.3%
 
88565.6%
 
36934.5%
 
65763.7%
 
25313.4%
 
144673.0%
 
184092.7%
 
113392.2%
 
12321.5%
 
Other values (13)10406.8%
 
(Missing)812352.7%
 
ValueCountFrequency (%) 
12321.5%
 
25313.4%
 
36934.5%
 
4970.6%
 
5880.6%
 
ValueCountFrequency (%) 
23520.3%
 
221210.8%
 
2111647.6%
 
201781.2%
 
191420.9%
 

Detail Cause
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count63
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Strain/Injury by Misc
 
1577
Strain/Injury by Lifting
 
1193
Struck by Falling/Flying Object
 
916
Misc, Other
 
838
Fall/Slip, Same Level
 
795
Other values (58)
10088
ValueCountFrequency (%) 
Strain/Injury by Misc157710.2%
 
Strain/Injury by Lifting11937.7%
 
Struck by Falling/Flying Object9165.9%
 
Misc, Other8385.4%
 
Fall/Slip, Same Level7955.2%
 
Misc, Foreign Body in Eye7785.0%
 
Cut/Puncture/Scrape, Object Lift/Handled7514.9%
 
Strike/Step On, Fixed Object7114.6%
 
Fall/Slip, Misc6314.1%
 
Fall/Slip, Different Level5453.5%
 
Other values (53)667243.3%
 

Length

Max length40
Median length25
Mean length25.54812747
Min length9

Detail Cause Code
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count63
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54.893749594340235
Minimum1
Maximum99
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile15
Q129
median58
Q377
95-th percentile99
Maximum99
Range98
Interquartile range (IQR)48

Descriptive statistics

Standard deviation26.95204326
Coefficient of variation (CV)0.4909856488
Kurtosis-1.189589794
Mean54.89374959
Median Absolute Deviation (MAD)25
Skewness-0.1202439998
Sum845748
Variance726.4126359
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
60157710.2%
 
5611937.7%
 
759165.9%
 
998385.4%
 
297955.2%
 
877785.0%
 
177514.9%
 
687114.6%
 
316314.1%
 
255453.5%
 
Other values (53)667243.3%
 
ValueCountFrequency (%) 
1230.1%
 
2490.3%
 
37< 0.1%
 
4310.2%
 
5280.2%
 
ValueCountFrequency (%) 
998385.4%
 
973502.3%
 
94200.1%
 
902321.5%
 
893< 0.1%
 

Domestic vs. Foreign?
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Domestic
15190
Foreign
 
217
ValueCountFrequency (%) 
Domestic1519098.6%
 
Foreign2171.4%
 

Length

Max length8
Median length8
Mean length7.985915493
Min length7

Domestic vs. Foreign? Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
D
15190
F
 
217
ValueCountFrequency (%) 
D1519098.6%
 
F2171.4%
 

Length

Max length1
Median length1
Mean length1
Min length1

Dt Reported to Carrier/TPA
Categorical

HIGH CARDINALITY

Distinct count3633
Unique (%)23.6%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
8/31/2011
 
15
7/24/2012
 
15
6/17/2013
 
15
3/26/2012
 
14
6/27/2014
 
14
Other values (3628)
15334
ValueCountFrequency (%) 
8/31/2011150.1%
 
7/24/2012150.1%
 
6/17/2013150.1%
 
3/26/2012140.1%
 
6/27/2014140.1%
 
11/22/2011140.1%
 
12/10/2002140.1%
 
8/26/2011140.1%
 
4/5/2004130.1%
 
11/14/2002130.1%
 
Other values (3623)1526699.1%
 

Length

Max length10
Median length9
Mean length8.944246122
Min length8

Dt Reported to Employer
Categorical

HIGH CARDINALITY

Distinct count4355
Unique (%)28.5%
Missing146
Missing (%)0.9%
Memory size120.4 KiB
8/15/2005
 
15
8/30/2011
 
14
6/5/2013
 
13
9/20/2011
 
13
9/13/2011
 
13
Other values (4350)
15193
ValueCountFrequency (%) 
8/15/2005150.1%
 
8/30/2011140.1%
 
6/5/2013130.1%
 
9/20/2011130.1%
 
9/13/2011130.1%
 
7/31/2013120.1%
 
7/24/2002120.1%
 
8/2/2012120.1%
 
3/19/2009120.1%
 
4/20/2011120.1%
 
Other values (4345)1513398.2%
 
(Missing)1460.9%
 

Length

Max length10
Median length9
Mean length8.882196404
Min length3

Employment Status
Categorical

HIGH CORRELATION

Distinct count12
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Unknown/Other
12564
Full-Time
 
2440
Seasonal
 
190
Part-Time
 
97
Piece Worker
 
66
Other values (7)
 
50
ValueCountFrequency (%) 
Unknown/Other1256481.5%
 
Full-Time244015.8%
 
Seasonal1901.2%
 
Part-Time970.6%
 
Piece Worker660.4%
 
On Strike180.1%
 
Apprenticeship Full-Time140.1%
 
Disabled90.1%
 
Retired3< 0.1%
 
Volunteer2< 0.1%
 
Other values (2)4< 0.1%
 

Length

Max length24
Median length13
Mean length12.27740637
Min length7

Employment Status Code
Categorical

HIGH CORRELATION

Distinct count12
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
7
12564
1
 
2440
8
 
190
2
 
97
C
 
66
Other values (7)
 
50
ValueCountFrequency (%) 
71256481.5%
 
1244015.8%
 
81901.2%
 
2970.6%
 
C660.4%
 
4180.1%
 
A140.1%
 
590.1%
 
63< 0.1%
 
92< 0.1%
 
Other values (2)4< 0.1%
 

Length

Max length1
Median length1
Mean length1
Min length1

Date of Injury/Illness
Categorical

HIGH CARDINALITY

Distinct count4430
Unique (%)28.8%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
10/3/2005
 
25
6/21/2005
 
19
6/22/2005
 
18
6/20/2013
 
16
9/30/2011
 
15
Other values (4425)
15314
ValueCountFrequency (%) 
10/3/2005250.2%
 
6/21/2005190.1%
 
6/22/2005180.1%
 
6/20/2013160.1%
 
9/30/2011150.1%
 
8/30/2011140.1%
 
4/20/2011130.1%
 
10/3/2003130.1%
 
5/6/2009130.1%
 
2/23/2001130.1%
 
Other values (4420)1524899.0%
 

Length

Max length10
Median length9
Mean length8.932563121
Min length8
Distinct count28
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
LOS ANGELE
7112
SACRAMENTO
1884
DALLAS WC
 
1345
NEW JERSEY
 
861
LONG ISLAN
 
534
Other values (23)
3671
ValueCountFrequency (%) 
LOS ANGELE711246.2%
 
SACRAMENTO188412.2%
 
DALLAS WC13458.7%
 
NEW JERSEY8615.6%
 
LONG ISLAN5343.5%
 
WC SOUTHEA5223.4%
 
CHARLOTTE5153.3%
 
IN-STATE A3532.3%
 
ATLANTA2971.9%
 
ILLINOIS2811.8%
 
Other values (18)170311.1%
 

Length

Max length10
Median length10
Mean length9.69942234
Min length6

How Injury Occurred
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count15344
Unique (%)99.6%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI
 
17
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN
 
7
UNKNOWN
 
7
EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S
 
7
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET.
 
5
Other values (15339)
15364
ValueCountFrequency (%) 
WORKING IN WOODED TALL GRASS AREA - EE WAS BITTEN BY DEER TI170.1%
 
WHILE WORKING IN A WOODED - TALL GRASS AREA - EE WAS BITTEN7< 0.1%
 
UNKNOWN7< 0.1%
 
EMPLOYEE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON S7< 0.1%
 
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET.5< 0.1%
 
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET4< 0.1%
 
EE WAS EXPOSED TO HEPATITIS A VIRUS WHILE WORKING ON SET - P3< 0.1%
 
COMPLAINED OF EYE IRRITATION UPON INSERTION OF CONTACT LENS.2< 0.1%
 
WHILE EE WORKING ON SET LOCATION HE DEVELOPED MULTIPLE PUSTU2< 0.1%
 
EE EXPERIENCED A CHEMICAL REACTION TO THE FUMES WHEN HE WAS2< 0.1%
 
Other values (15334)1535199.6%
 

Length

Max length60
Median length60
Mean length57.90601675
Min length7

Injury/Illness City
Categorical

HIGH CARDINALITY

Distinct count1340
Unique (%)8.7%
Missing1
Missing (%)< 0.1%
Memory size120.4 KiB
LOS ANGELES
2294
UNKNOWN
 
1538
BURBANK
 
1506
NEW ORLEANS
 
610
NEW YORK
 
393
Other values (1335)
9065
ValueCountFrequency (%) 
LOS ANGELES229414.9%
 
UNKNOWN153810.0%
 
BURBANK15069.8%
 
NEW ORLEANS6104.0%
 
NEW YORK3932.6%
 
BROOKLYN3882.5%
 
WILMINGTON3282.1%
 
CULVER CITY2981.9%
 
AUSTIN2611.7%
 
ATLANTA2221.4%
 
Other values (1330)756849.1%
 

Length

Max length19
Median length8
Mean length9.119101707
Min length1

Injury/Illness Postal
Categorical

HIGH CARDINALITY
MISSING

Distinct count1841
Unique (%)15.7%
Missing3684
Missing (%)23.9%
Memory size120.4 KiB
91502
 
1369
95816
 
406
90038
 
303
90001
 
222
90028
 
219
Other values (1836)
9204
ValueCountFrequency (%) 
9150213698.9%
 
958164062.6%
 
900383032.0%
 
900012221.4%
 
900282191.4%
 
915051991.3%
 
902321711.1%
 
915041671.1%
 
916081581.0%
 
915211270.8%
 
Other values (1831)838254.4%
 
(Missing)368423.9%
 

Length

Max length9
Median length5
Mean length4.513467904
Min length3

Injury/Illness State
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count53
Unique (%)0.3%
Missing12
Missing (%)0.1%
Memory size120.4 KiB
California
8019
New York
 
1356
Louisiana
 
1132
Georgia
 
654
North Carolina
 
583
Other values (48)
3651
ValueCountFrequency (%) 
California801952.0%
 
New York13568.8%
 
Louisiana11327.3%
 
Georgia6544.2%
 
North Carolina5833.8%
 
Texas4032.6%
 
New Mexico3832.5%
 
Pennsylvania3112.0%
 
Michigan2741.8%
 
Utah2631.7%
 
Other values (43)201713.1%
 

Length

Max length25
Median length10
Mean length9.506003765
Min length3

Injury/Illness State Code
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct count53
Unique (%)0.3%
Missing12
Missing (%)0.1%
Memory size120.4 KiB
CA
8019
NY
 
1356
LA
 
1132
GA
 
654
NC
 
583
Other values (48)
3651
ValueCountFrequency (%) 
CA801952.0%
 
NY13568.8%
 
LA11327.3%
 
GA6544.2%
 
NC5833.8%
 
TX4032.6%
 
NM3832.5%
 
PA3112.0%
 
MI2741.8%
 
UT2631.7%
 
Other values (43)201713.1%
 

Length

Max length3
Median length2
Mean length2.000778867
Min length2

Jurisdiction
Categorical

HIGH CORRELATION

Distinct count47
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
California
9094
New York
 
1525
Louisiana
 
851
Georgia
 
565
North Carolina
 
535
Other values (42)
2837
ValueCountFrequency (%) 
California909459.0%
 
New York15259.9%
 
Louisiana8515.5%
 
Georgia5653.7%
 
North Carolina5353.5%
 
Texas3532.3%
 
New Mexico3322.2%
 
Pennsylvania2441.6%
 
Illinois2411.6%
 
Utah2361.5%
 
Other values (37)14319.3%
 

Length

Max length20
Median length10
Mean length9.506523009
Min length4

Jurisdiction Code
Categorical

HIGH CORRELATION

Distinct count47
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
CA
9094
NY
 
1525
LA
 
851
GA
 
565
NC
 
535
Other values (42)
2837
ValueCountFrequency (%) 
CA909459.0%
 
NY15259.9%
 
LA8515.5%
 
GA5653.7%
 
NC5353.5%
 
TX3532.3%
 
NM3322.2%
 
PA2441.6%
 
IL2411.6%
 
UT2361.5%
 
Other values (37)14319.3%
 

Length

Max length2
Median length2
Mean length2
Min length2

Lost Time or Medical Only?
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing11
Missing (%)0.1%
Memory size120.4 KiB
Medical Only
11684
Lost Time
3712
ValueCountFrequency (%) 
Medical Only1168475.8%
 
Lost Time371224.1%
 
(Missing)110.1%
 

Length

Max length12
Median length12
Mean length11.27078601
Min length3

Lost Time or Medical Only? Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing11
Missing (%)0.1%
Memory size120.4 KiB
MO
11684
LT
3712
ValueCountFrequency (%) 
MO1168475.8%
 
LT371224.1%
 
(Missing)110.1%
 

Length

Max length3
Median length2
Mean length2.000713961
Min length2

Nature of Injury/Illness
Categorical

HIGH CORRELATION

Distinct count45
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size120.4 KiB
Strain
3583
Laceration
2418
Specific Injury - All Other
2221
Contusion
1610
Sprain
1025
Other values (40)
4550
ValueCountFrequency (%) 
Strain358323.3%
 
Laceration241815.7%
 
Specific Injury - All Other222114.4%
 
Contusion161010.4%
 
Sprain10256.7%
 
Puncture7855.1%
 
Foreign Body7594.9%
 
Inflammation6704.3%
 
Fracture5703.7%
 
Infection2001.3%
 
Other values (35)156610.2%
 

Length

Max length59
Median length9
Mean length11.81729084
Min length4

Nature of Injury/Illness Code
Real number (ℝ≥0)

Distinct count45
Unique (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean41.65898617511521
Minimum1
Maximum91
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile10
Q136
median43
Q352
95-th percentile59
Maximum91
Range90
Interquartile range (IQR)16

Descriptive statistics

Standard deviation17.19567328
Coefficient of variation (CV)0.4127722458
Kurtosis0.08174911361
Mean41.65898618
Median Absolute Deviation (MAD)9
Skewness-0.4530364745
Sum641840
Variance295.6911796
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
52358323.3%
 
40241815.7%
 
59222114.4%
 
10161010.4%
 
4910256.7%
 
437855.1%
 
257594.9%
 
376704.3%
 
285703.7%
 
362001.3%
 
Other values (35)156610.2%
 
ValueCountFrequency (%) 
1720.5%
 
2110.1%
 
34< 0.1%
 
41771.1%
 
7720.5%
 
ValueCountFrequency (%) 
91650.4%
 
901200.8%
 
80560.4%
 
78150.1%
 
77140.1%
 

Number of Dependents
Real number (ℝ≥0)

MISSING

Distinct count9
Unique (%)1.5%
Missing14808
Missing (%)96.1%
Infinite0
Infinite (%)0.0%
Mean1.9131886477462436
Minimum1.0
Maximum18.0
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q32
95-th percentile4
Maximum18
Range17
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.334821653
Coefficient of variation (CV)0.6976947384
Kurtosis38.79484103
Mean1.913188648
Median Absolute Deviation (MAD)1
Skewness4.345641318
Sum1146
Variance1.781748846
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
12811.8%
 
21871.2%
 
3840.5%
 
4290.2%
 
580.1%
 
64< 0.1%
 
93< 0.1%
 
72< 0.1%
 
181< 0.1%
 
(Missing)1480896.1%
 
ValueCountFrequency (%) 
12811.8%
 
21871.2%
 
3840.5%
 
4290.2%
 
580.1%
 
ValueCountFrequency (%) 
181< 0.1%
 
93< 0.1%
 
72< 0.1%
 
64< 0.1%
 
580.1%
 

OSHA Injury Type
Categorical

HIGH CORRELATION

Distinct count6
Unique (%)< 0.1%
Missing2
Missing (%)< 0.1%
Memory size120.4 KiB
Injury
15128
Skin disorder
 
156
Respiratory condition
 
60
Poisoning
 
27
Hearing loss
 
26
ValueCountFrequency (%) 
Injury1512898.2%
 
Skin disorder1561.0%
 
Respiratory condition600.4%
 
Poisoning270.2%
 
Hearing loss260.2%
 
All other illnesses80.1%
 
(Missing)2< 0.1%
 

Length

Max length21
Median length6
Mean length6.151035244
Min length3

OSHA Injury Type Code
Real number (ℝ≥0)

Distinct count6
Unique (%)< 0.1%
Missing2
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean1.0325219084712756
Minimum1.0
Maximum6.0
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile1
Maximum6
Range5
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.2835746844
Coefficient of variation (CV)0.2746427772
Kurtosis142.0491387
Mean1.032521908
Median Absolute Deviation (MAD)0
Skewness11.12582568
Sum15906
Variance0.08041460165
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
11512898.2%
 
21561.0%
 
3600.4%
 
4270.2%
 
5260.2%
 
680.1%
 
(Missing)2< 0.1%
 
ValueCountFrequency (%) 
11512898.2%
 
21561.0%
 
3600.4%
 
4270.2%
 
5260.2%
 
ValueCountFrequency (%) 
680.1%
 
5260.2%
 
4270.2%
 
3600.4%
 
21561.0%
 

Severity Index Code
Categorical

MISSING

Distinct count10
Unique (%)0.1%
Missing344
Missing (%)2.2%
Memory size120.4 KiB
No Serious Injury Indicated
15000
Fatality
 
19
Fractured Bone(s)
 
15
Back Injury involving Surgery/Extended Disability
 
10
Involves AIDS, Herpes, TSS, Cancer, Other Diseases
 
5
Other values (5)
 
14
ValueCountFrequency (%) 
No Serious Injury Indicated1500097.4%
 
Fatality190.1%
 
Fractured Bone(s)150.1%
 
Back Injury involving Surgery/Extended Disability100.1%
 
Involves AIDS, Herpes, TSS, Cancer, Other Diseases5< 0.1%
 
Heart Attack or Cardio-Vascular Accident4< 0.1%
 
Serious Head Injury4< 0.1%
 
Serious Burns2< 0.1%
 
Minor Amputation2< 0.1%
 
Major Amputation2< 0.1%
 
(Missing)3442.2%
 

Length

Max length50
Median length27
Mean length26.44934121
Min length3

Severity Index Code Code
Real number (ℝ≥0)

MISSING

Distinct count10
Unique (%)0.1%
Missing344
Missing (%)2.2%
Infinite0
Infinite (%)0.0%
Mean9.983270264887473
Minimum1.0
Maximum15.0
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum1
5-th percentile10
Q110
median10
Q310
95-th percentile10
Maximum15
Range14
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.3783217512
Coefficient of variation (CV)0.03789557341
Kurtosis459.3414733
Mean9.983270265
Median Absolute Deviation (MAD)0
Skewness-19.43872707
Sum150378
Variance0.1431273474
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
101500097.4%
 
1190.1%
 
9150.1%
 
7100.1%
 
145< 0.1%
 
64< 0.1%
 
44< 0.1%
 
152< 0.1%
 
22< 0.1%
 
52< 0.1%
 
(Missing)3442.2%
 
ValueCountFrequency (%) 
1190.1%
 
22< 0.1%
 
44< 0.1%
 
52< 0.1%
 
64< 0.1%
 
ValueCountFrequency (%) 
152< 0.1%
 
145< 0.1%
 
101500097.4%
 
9150.1%
 
7100.1%
 

Time of Injury/Illness
Real number (ℝ≥0)

ZEROS

Distinct count581
Unique (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1010.9847471928344
Minimum0
Maximum2359
Zeros2828
Zeros (%)18.4%
Memory size120.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1615
median1035
Q31510
95-th percentile2025
Maximum2359
Range2359
Interquartile range (IQR)895

Descriptive statistics

Standard deviation660.7386831
Coefficient of variation (CV)0.6535594973
Kurtosis-0.9523935227
Mean1010.984747
Median Absolute Deviation (MAD)465
Skewness-0.1933581149
Sum15576242
Variance436575.6074
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0282818.4%
 
10006614.3%
 
14005383.5%
 
11005303.4%
 
15004703.1%
 
9004072.6%
 
16004012.6%
 
13003862.5%
 
8003842.5%
 
17003001.9%
 
Other values (571)850255.2%
 
ValueCountFrequency (%) 
0282818.4%
 
12< 0.1%
 
21< 0.1%
 
41< 0.1%
 
5150.1%
 
ValueCountFrequency (%) 
23592< 0.1%
 
23557< 0.1%
 
23531< 0.1%
 
23507< 0.1%
 
23481< 0.1%
 

Type of Loss
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing53
Missing (%)0.3%
Memory size120.4 KiB
Specific Injury
15195
Cumulative Trauma
 
159
ValueCountFrequency (%) 
Specific Injury1519598.6%
 
Cumulative Trauma1591.0%
 
(Missing)530.3%
 

Length

Max length17
Median length15
Mean length14.97936003
Min length3

Type of Loss Code
Categorical

HIGH CORRELATION

Distinct count2
Unique (%)< 0.1%
Missing53
Missing (%)0.3%
Memory size120.4 KiB
3
15195
1
 
159
ValueCountFrequency (%) 
31519598.6%
 
11591.0%
 
(Missing)530.3%
 

Length

Max length3
Median length3
Mean length3
Min length3

Policy Year
Real number (ℝ≥0)

Distinct count15
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2007.6086194586876
Minimum2000
Maximum2014
Zeros0
Zeros (%)0.0%
Memory size120.4 KiB

Quantile statistics

Minimum2000
5-th percentile2000
Q12004
median2008
Q32011
95-th percentile2014
Maximum2014
Range14
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.268828711
Coefficient of variation (CV)0.002126325156
Kurtosis-1.203913341
Mean2007.608619
Median Absolute Deviation (MAD)4
Skewness-0.1645031735
Sum30931226
Variance18.22289857
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
201114409.3%
 
201313258.6%
 
201211967.8%
 
200511417.4%
 
201411237.3%
 
201010957.1%
 
200410296.7%
 
20089696.3%
 
20029506.2%
 
20099326.0%
 
Other values (5)420727.3%
 
ValueCountFrequency (%) 
20007785.0%
 
20016974.5%
 
20029506.2%
 
20039085.9%
 
200410296.7%
 
ValueCountFrequency (%) 
201411237.3%
 
201313258.6%
 
201211967.8%
 
201114409.3%
 
201010957.1%
 

Reforms_dummy
Categorical

MISSING

Distinct count3
Unique (%)< 0.1%
Missing6313
Missing (%)41.0%
Memory size120.4 KiB
California Refom 1
4983
California Refom 0
3022
California Reform 2
1089
ValueCountFrequency (%) 
California Refom 1498332.3%
 
California Refom 0302219.6%
 
California Reform 210897.1%
 
(Missing)631341.0%
 

Length

Max length19
Median length18
Mean length11.92444993
Min length3

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

Obs_IDDependentAverage Weekly WageBody PartBody Part CodeCauseCause CodeClaimant AgeClaimant Atty Firm NameClaimant GenderClaimant Gender CodeClaimant Hire DateClaimant Marital StatusClaimant Marital Status CodeClaimant StateClaimant State CodeDepartment CodeDetail CauseDetail Cause CodeDomestic vs. Foreign?Domestic vs. Foreign? CodeDt Reported to Carrier/TPADt Reported to EmployerEmployment StatusEmployment Status CodeDate of Injury/IllnessHandling Office NameHow Injury OccurredInjury/Illness CityInjury/Illness PostalInjury/Illness StateInjury/Illness State CodeJurisdictionJurisdiction CodeLost Time or Medical Only?Lost Time or Medical Only? CodeNature of Injury/IllnessNature of Injury/Illness CodeNumber of DependentsOSHA Injury TypeOSHA Injury Type CodeSeverity Index CodeSeverity Index Code CodeTime of Injury/IllnessType of LossType of Loss CodePolicy YearReforms_dummy
0Obs_198679500Pelvis46Struck or Injured By170021.0NaNFemaleF4/3/2001NaNNaNCaliforniaCANaNStruck by Falling/Flying Object75DomesticD4/17/20014/13/2001Full-Time14/13/2001LOS ANGELEGOING DOWN SKI HILL ON AN AIR MATTRESS AS PART OF A SKIT,PORTLAND97201OregonORCaliforniaCALost TimeLTFracture28NaNInjury1.0Fractured Bone(s)9.01430Specific Injury3.02001California Refom 0
1Obs_2557271,037.00Low Back Area42Strain or Injury By1500NaNNaNMaleM5/15/2001NaNNaNCaliforniaCANaNStrain/Injury by Lifting56DomesticD5/25/20015/24/2001Full-Time15/22/2001IN-STATE AREPETITIVE LIFTING OF CABLE, EE STRAINED LOWER BACKPEARL HARBORNaNHawaiiHIHawaiiHILost TimeLTStrain521.0Injury1.0No Serious Injury Indicated10.00Specific Injury3.02001NaN
2Obs_3185833929Low Back Area42Strain or Injury By150063.0TROBINSON & CHUR ATTORNEYS AT LAWMaleM5/15/2001MarriedMHawaiiHINaNStrain/Injury by Carrying55DomesticD5/31/20015/22/2001Unknown/Other75/22/2001IN-STATE ASTRAINED LOW BACK MOVING A PALM TREE WITH CO-WORKERPEARL HARBOR96860HawaiiHIHawaiiHILost TimeLTStrain52NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02001NaN
3Obs_4986151,226.00Multiple Body Parts90Strain or Injury By150049.0IBARRY STEVENS;;M;;MaleMNaNNaNNaNIdahoIDNaNStrain/Injury by Repetitive Motion97DomesticD12/31/200312/23/2003Unknown/Other73/31/2002LOS ANGELEEE CLAIMS: CT 1973 -/02 TO BOTH SHOULDERS - SPINE - AND EARBURBANK91502CaliforniaCACaliforniaCALost TimeLTSpecific Injury - All Other59NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02002California Refom 0
4Obs_551396NaNOther Facial Soft Tissue18Miscellaneous Causes190051.0IBARRY STEVENS;;M;;MaleMNaNNaNNaNIdahoIDNaNMisc, No Physical Cause90DomesticD2/18/20042/17/2004Unknown/Other78/1/2003LOS ANGELEEMPLOYEE CLAIMS: CT 11/16/93 -8/1/03; PHYSICAL STRESS AND STBURBANK91502CaliforniaCACaliforniaCALost TimeLTSpecific Injury - All Other59NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02003California Refom 0
5Obs_64079NaNMultiple Upper Extremities30Strain or Injury By150055.0IWAX & WAX;;A;;MaleMNaNNaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD3/19/20043/19/2004Unknown/Other712/31/2002LOS ANGELEEE CLAIMS: CT 1980 -NOV 2003 TO NECK - BACK - BOTH UPPER EXTBURBANK91502CaliforniaCACaliforniaCALost TimeLTCarpal Tunnel Syndrome78NaNInjury1.0No Serious Injury Indicated10.00Cumulative Trauma1.02002California Refom 0
6Obs_819091,129.00Low Back Area42Strain or Injury By150049.0TCRAIG RICHLINMaleM1/22/2000NaNNaNCaliforniaCANaNStrain/Injury by Misc60DomesticD6/10/20046/7/2004Unknown/Other712/31/2000LOS ANGELEEE CLAIMS CT 09/25/00 09/25/01 TO LEFT LOWER EXTREMITY AND BUNKNOWNNaNCaliforniaCACaliforniaCALost TimeLTSpecific Injury - All Other59NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02000California Refom 0
7Obs_96687NaNLow Back Area42Strain or Injury By150036.0NaNMaleMNaNNaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD7/8/20046/28/2004Unknown/Other72/21/2001LOS ANGELEEE CLAIMS REPETITIVE BACK INJURY CT 8/1/99-11/03 FROM REPETIMISSION HILLS91345CaliforniaCACaliforniaCALost TimeLTStrain52NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02001California Refom 0
8Obs_105352NaNLow Back Area42Strain or Injury By150045.0NaNMaleMNaNNaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD7/8/20047/2/2004Unknown/Other74/23/2003LOS ANGELEEE CLAIMS; CT 4/23/02-4/23/03 TO SPINE. BILATERAL UPPER EXTRBURBANK91504CaliforniaCACaliforniaCALost TimeLTStrain52NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02003California Refom 0
9Obs_1163241,000.00Lower Leg54Strain or Injury By150045.0NaNMaleM10/3/2002NaNNaNCaliforniaCANaNStrain/Injury by Repetitive Motion97DomesticD8/4/20048/2/2004Full-Time110/30/2002LOS ANGELEEE CLAIMS: L LEG - VENUS THROMBOSIS WHILE WORKING IN LAS VEGLAS VEGAS89104NevadaNVCaliforniaCALost TimeLTStrain52NaNInjury1.0No Serious Injury Indicated10.00Specific Injury3.02002California Refom 0

Last rows

Obs_IDDependentAverage Weekly WageBody PartBody Part CodeCauseCause CodeClaimant AgeClaimant Atty Firm NameClaimant GenderClaimant Gender CodeClaimant Hire DateClaimant Marital StatusClaimant Marital Status CodeClaimant StateClaimant State CodeDepartment CodeDetail CauseDetail Cause CodeDomestic vs. Foreign?Domestic vs. Foreign? CodeDt Reported to Carrier/TPADt Reported to EmployerEmployment StatusEmployment Status CodeDate of Injury/IllnessHandling Office NameHow Injury OccurredInjury/Illness CityInjury/Illness PostalInjury/Illness StateInjury/Illness State CodeJurisdictionJurisdiction CodeLost Time or Medical Only?Lost Time or Medical Only? CodeNature of Injury/IllnessNature of Injury/Illness CodeNumber of DependentsOSHA Injury TypeOSHA Injury Type CodeSeverity Index CodeSeverity Index Code CodeTime of Injury/IllnessType of LossType of Loss CodePolicy YearReforms_dummy
15397Obs_19459264NaNAbdomen including Groin61Strain or Injury By150038.0NaNMaleM1/1/2014NaNNaNVirginiaVA18.0Strain/Injury by Lifting56DomesticD10/20/201410/20/2014Unknown/Other710/20/2014WC SOUTHEAPATIENT WAS LIFTING LENS CASES, STATES SOMETHING DID NOT FEERICHMOND23222VirginiaVAVirginiaVAMedical OnlyMOStrain52NaNInjury1.0No Serious Injury Indicated10.0830Specific Injury3.02014NaN
15398Obs_194601034NaNBrain12Struck or Injured By170048.0NaNMaleM7/21/2014NaNNaNFloridaFL20.0Struck by Motor Vehicle77DomesticD10/20/2014NaNUnknown/Other710/17/2014WC SOUTHEAEE WAS PERFORMING A STUNT WHEN HE GOT HIT BY A PICTURE CAR ASTONE MOUNTAIN30087GeorgiaGAFloridaFLMedical OnlyMOConcussion7NaNInjury1.0No Serious Injury Indicated10.02230Specific Injury3.02014NaN
15399Obs_19461926NaNLower Leg54Cut, Puncture, Scrape Injured By120060.0NaNMaleM9/14/2014NaNNaNArizonaAZ19.0Cut/Puncture/Scrape, Object Lift/Handled17DomesticD10/21/201410/8/2014Unknown/Other710/3/2014WC SOUTHEAEE STATES WHILE MOVING STEEL HE LACERATED HIS R UPPER ASPECTFAYETTEVILLE30214GeorgiaGAGeorgiaGAMedical OnlyMOInfection36NaNInjury1.0No Serious Injury Indicated10.01100Specific Injury3.02014NaN
15400Obs_19463780NaNShoulder(s)38Strain or Injury By150039.0NaNFemaleF4/30/2014NaNNaNGeorgiaGA8.0Strain/Injury by Carrying55DomesticD10/22/201410/20/2014Unknown/Other710/20/2014WC SOUTHEAWHILE LOADING THE TRAILER EE FELT DISCOMFORT IN R SHOULDER.SENOIA30276GeorgiaGAGeorgiaGAMedical OnlyMOStrain52NaNInjury1.0No Serious Injury Indicated10.01818Specific Injury3.02014NaN
15401Obs_194670NaNHand35Cut, Puncture, Scrape Injured By120044.0NaNMaleM7/26/2014NaNNaNNorth CarolinaNC8.0Cut/Puncture/Scrape, Hand Tool16DomesticD10/24/201410/24/2014Unknown/Other710/24/2014WC SOUTHEAEMPLOYEE WAS CUTTING ZIP TIES WITH A KNIFE WHEN IT SLIPPED OWILMINGTON28401North CarolinaNCNorth CarolinaNCMedical OnlyMOLaceration40NaNInjury1.0No Serious Injury Indicated10.0830Specific Injury3.02014NaN
15402Obs_194732405NaNKnee53Fall, Slip or Trip Injury130021.0NaNFemaleF8/20/2014NaNNaNGeorgiaGA6.0Fall/Slip, Into Opening28DomesticD10/29/201410/29/2014Unknown/Other710/29/2014WC SOUTHEAEMPLOYEE WAS RETRIEVING PAINT SUPPLIES FROM A TRAILER WHEN SFAYETTEVILLE30214GeorgiaGAGeorgiaGAMedical OnlyMOInflammation37NaNInjury1.0No Serious Injury Indicated10.01115Specific Injury3.02014NaN
15403Obs_1947518076,486.00Shoulder(s)38Strain or Injury By150033.0NaNMaleM10/20/2014NaNNaNGeorgiaGA20.0Strain/Injury by Misc60DomesticD10/30/201410/30/2014Full-Time110/30/2014WC SOUTHEAPATIENT WAS IN A SCENE THAT REQUIRED HIM TO RUN, STOP AND FAPEACHTREE CITYNaNGeorgiaGAGeorgiaGALost TimeLTStrain52NaNInjury1.0No Serious Injury Indicated10.01558Specific Injury3.02014NaN
15404Obs_194890NaNAnkle55Strain or Injury By150033.0NaNMaleM1/1/2014Unmarried, Single, Widowed, DivorcedUVirginiaVA22.0Strain/Injury by Jumping54DomesticD11/6/201411/5/2014Unknown/Other711/5/2014WC SOUTHEAPATIENT JUMPED OVER A 4' WOODEN FENCE, LANDED ON UNEVEN GROUHENRICO23238VirginiaVAVirginiaVAMedical OnlyMOSprain49NaNInjury1.0No Serious Injury Indicated10.01900Specific Injury3.02014NaN
15405Obs_19501507NaNArm33Strain or Injury By150034.0NaNMaleM8/22/2014NaNNaNGeorgiaGA3.0Strain/Injury by Misc60DomesticD11/11/201411/10/2014Unknown/Other711/10/2014WC SOUTHEAPATIENT STATED HE WAS INJURED WHEN PLASTERING WALLS. PRODUCTHIRAM30141GeorgiaGAGeorgiaGAMedical OnlyMOStrain52NaNInjury1.0No Serious Injury Indicated10.01041Specific Injury3.02014NaN
15406Obs_195100NaNLow Back Area42Strain or Injury By150049.0NaNFemaleF10/6/2014NaNNaNMissouriMO11.0Strain/Injury by Twisting53DomesticD11/17/201411/17/2014Unknown/Other711/14/2014WC SOUTHEAWHILE PERFORMING REQUIRED JOB DUTIES, EE TWISTED HER BACK, ANASHVILLE37214TennesseeTNSouth CarolinaSCMedical OnlyMOStrain52NaNInjury1.0No Serious Injury Indicated10.01930Specific Injury3.02014NaN